﻿/*

*/
SET NUMERIC_ROUNDABORT OFF
GO
SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
-- Pointer used for text / image updates. This might not be needed, but is declared here just in case
DECLARE @pv binary(16)

BEGIN TRANSACTION
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'AK', N'ALASKA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'AL', N'ALABAMA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'AR', N'ARKANSAS')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'AS', N'AMERICAN SAMOA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'AZ', N'ARIZONA ')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'CA', N'CALIFORNIA ')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'CO', N'COLORADO ')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'CT', N'CONNECTICUT')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'DC', N'DISTRICT OF COLUMBIA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'DE', N'DELAWARE')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'FL', N'FLORIDA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'FM', N'FEDERATED STATES OF MICRONESIA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'GA', N'GEORGIA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'GU', N'GUAM ')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'HI', N'HAWAII')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'IA', N'IOWA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'ID', N'IDAHO')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'IL', N'ILLINOIS')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'IN', N'INDIANA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'KS', N'KANSAS')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'KY', N'KENTUCKY')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'LA', N'LOUISIANA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'MA', N'MASSACHUSETTS')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'MD', N'MARYLAND')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'ME', N'MAINE')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'MH', N'MARSHALL ISLANDS')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'MI', N'MICHIGAN')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'MN', N'MINNESOTA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'MO', N'MISSOURI')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'MP', N'NORTHERN MARIANA ISLANDS')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'MS', N'MISSISSIPPI')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'MT', N'MONTANA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'NC', N'NORTH CAROLINA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'ND', N'NORTH DAKOTA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'NE', N'NEBRASKA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'NH', N'NEW HAMPSHIRE')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'NJ', N'NEW JERSEY')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'NM', N'NEW MEXICO')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'NV', N'NEVADA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'NY', N'NEW YORK')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'OH', N'OHIO')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'OK', N'OKLAHOMA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'OR', N'OREGON')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'PA', N'PENNSYLVANIA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'PR', N'PUERTO RICO')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'PW', N'PALAU')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'RI', N'RHODE ISLAND')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'SC', N'SOUTH CAROLINA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'SD', N'SOUTH DAKOTA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'TN', N'TENNESSEE')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'TX', N'TEXAS')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'UT', N'UTAH')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'VA', N'VIRGINIA ')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'VI', N'VIRGIN ISLANDS')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'VT', N'VERMONT')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'WA', N'WASHINGTON')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'WI', N'WISCONSIN')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'WV', N'WEST VIRGINIA')
INSERT INTO [dbo].[States] ([Code], [Name]) VALUES (N'WY', N'WYOMING')
SET IDENTITY_INSERT [dbo].[Invoice] ON
INSERT INTO [dbo].[Invoice] ([InvoiceNumber], [Total], [State]) VALUES (1, 13.5400, N'AK')
INSERT INTO [dbo].[Invoice] ([InvoiceNumber], [Total], [State]) VALUES (2, 456.3600, N'CT')
INSERT INTO [dbo].[Invoice] ([InvoiceNumber], [Total], [State]) VALUES (3, 354.6700, N'TX')
INSERT INTO [dbo].[Invoice] ([InvoiceNumber], [Total], [State]) VALUES (4, 54.6300, N'AK')
INSERT INTO [dbo].[Invoice] ([InvoiceNumber], [Total], [State]) VALUES (5, 254.3400, N'TX')
INSERT INTO [dbo].[Invoice] ([InvoiceNumber], [Total], [State]) VALUES (6, 34.4300, N'CT')
INSERT INTO [dbo].[Invoice] ([InvoiceNumber], [Total], [State]) VALUES (7, 67.3400, N'AL')
INSERT INTO [dbo].[Invoice] ([InvoiceNumber], [Total], [State]) VALUES (8, 34.6400, N'CT')
INSERT INTO [dbo].[Invoice] ([InvoiceNumber], [Total], [State]) VALUES (9, 23.6500, N'AK')
INSERT INTO [dbo].[Invoice] ([InvoiceNumber], [Total], [State]) VALUES (10, 65.7600, N'AL')
INSERT INTO [dbo].[Invoice] ([InvoiceNumber], [Total], [State]) VALUES (11, 45.7600, N'TX')
SET IDENTITY_INSERT [dbo].[Invoice] OFF
COMMIT TRANSACTION
